#!/Library/Frameworks/Python.framework/Versions/3.7/bin/python3.7
# -*- coding: utf-8 -*- 例如，可添加# -*- coding: utf-8 -*-

from openpyxl import load_workbook

table_name = "audio_info"
wb2 = load_workbook('%s.xlsx' % (table_name))
ws=wb2.get_sheet_names
for row in wb2:

    i = 11;
    for cell in row:
        # 更新订单表支付失败（我的购买中不再显示已兑换的内容）
        i = i + 1;
        insert2sql = 'INSERT INTO audio_img VALUES (%s, %s, "/data/img/img/2018/12/13/cbd4a04e08a6484fa5fd907110980d2d.jpg", "jpeg", 640, 640, "NULL", 1);' % (i, cell[0].value)
        print(insert2sql)

print("over...")
